Data Analytics
Dashboard
Module 1: Introduction
1.1
Introduction to course
Module 2: Excel Basics
2.1
Basics
2.2
Worksheet Basics
2.3
Data Formats
2.4
Data Handling Basics Cut, Copy & Paste
2.5
Saving and Printing Basics
Module 3: Essential Formulas
3.1
Basic Formula Operations
3.2
Mathematical Functions 1
3.3
Mathematical Functions 2
3.4
Textual Functions Part 1
3.5
Textual Functions 2
3.6
Logical Functions
3.7
Date-Time Functions
3.8
Lookup functions (VLOOKUP,HLOOKUP,INDEX-MATCH)
Module 4: Xlookup - Only for Excel 2021 and Office 365
4.1
XLOOKUP as a replacement of VLOOKUP
4.2
Handling NA and approximate match in XLookup
4.3
Wildcard matching in XLOOKUP
4.4
Search modes
Module 5: Data Tools
5.1
Sorting, Filtering and Data Validation
5.2
Text-to-columns and remove duplicates
5.3
Advanced Filter option
5.4
Formatting Data and Tables
Module 6: Excel Charts
6.1
Importance of Data Visualization
6.2
Elements of Charts
6.3
The Easy way of Creating Charts
6.4
Bar and Column Charts
6.5
Formatting Charts Part 1
6.6
Formatting Charts Part 2
6.7
Line Charts
6.8
Area Charts
6.9
Pie and Doughnut Charts
6.10
Scatter plot or XY Chart
6.11
Waterfall Charts
6.12
Sparklines
6.13
Pivot Tables
Module 7: Pivot Tables and Pivot Charts
7.1
Pivot Tables
7.2
Pivot Charts
Module 8: Map Charts- Only for Excel 2019 & above
8.1
Maps Chart
Module 9: Using ChatGPT with Excel
9.1
Use ChatGPT For Excel Problems
Module 10: Macros
10.1
Macros
Module 11: Importing Data from External Sources
11.1
Importing Data from Websites Excel 2019 and 365
Module 12: SQL Introduction
12.1
Introduction
Module 13: Installation and getting started
13.1
Installing SQL Server and SSMS in your system
Module 14: Database Basics
14.1
What is SQL
14.2
Tables and DBMS
14.3
Types of SQL Commands
Module 15: Fundamental SQL Statements
15.1
CREATE
15.2
INSERT
15.3
Primary Key Foreign Key
15.4
Import data from file
15.5
Select
15.6
SELECT DISTINCT
15.7
WHERE
15.8
Logical Operators
15.9
UPDATE
15.10
DELETE
15.11
ALTER Part 1
15.12
ALTER Part 2
Module 16: Restore and Backup
16.1
Restore and Backup
16.2
Backup and Restore-Adventure Works DB
16.3
Creating tables using CSV files
Module 17: Selection Commands: Filtering
17.1
IN
17.2
BETWEEN
17.3
LIKE
Module 18: Selection Commands:Ordering
18.1
Side Lecture Commenting in SQL
18.2
ORDER BY
18.3
TOP (LIMIT)
Module 19: Aliasing
19.1
AS
Module 20: Aggregate Commands
20.1
COUNT
20.2
SUM
20.3
AVG
20.4
MIN MAX
Module 21: GROUP BY
21.1
GROUP BY
21.2
HAVING
Module 22: Conditional Statement
22.1
CASE WHEN
Module 23: JOINS
23.1
Introduction to Joins
23.2
Concepts of Joining and Combining Data
23.3
Preparing the Data
23.4
INNER JOIN
23.5
LEFT JOIN
23.6
RIGHT JOIN
23.7
FULL OUTER JOIN
23.8
CROSS JOIN
23.9
INTERSECT
23.10
EXCEPT
23.11
UNION ALL
Module 24: Subqueries
24.1
Part 1 - Subquery in WHERE Clause
24.2
Part 2 - Subquery in FROM clause
24.3
Part 3 - Subquery in SELECT Clause
Module 25: Views and Indexes
25.1
VIEW
25.2
INDEX
Module 26: String Functions
26.1
LENGTH
26.2
UPPER LOWER
26.3
REPLACE
26.4
TRIM LTRIM RTRIM
26.5
Concatenation
26.6
SUBSTRING
26.7
LIST AGGREGATION
Module 27: Mathematical Functions
27.1
CEIL FLOOR
27.2
RANDOM
27.3
ROUND
27.4
POWER
Module 28: DATE TIME Functions
28.1
Current date time
28.2
AGE - DATEDIFF
28.3
EXTRACT - DATE AND TIME PARTS
Module 29: Pattern(String)Matching
29.1
PATTERN MATCHING BASICS
29.2
PATTERN MATCHING PART 1
29.3
advance pattern matching part 2
Module 30: Window functions
30.1
Introduction to window functions
30.2
Introduction to Row numbers
30.3
Implementing row number in SQL
30.4
RANK and DENSERANK
30.5
NTILE
30.6
AVERAGE Window Function
30.7
COUNT WINDOW FUNC
30.8
SUM TOTAL
30.9
RUNNING TOTAL
30.10
LAG and LEAD
Module 31: Data type conversion functions
31.1
Converting number date to string and string to date
Module 32: Python Course welcome & setup
32.1
Python Overview
Module 33: Objects, variables and data types
33.1
Objects and Variables overview
33.2
Numbers
33.3
Strings
33.4
String Operations
33.5
String Methods and Properties
33.6
String Concatenation and Formatting
33.7
lists part 1
33.8
LISTS part 2
33.9
Dictionary
33.10
Tuples and Sets
33.11
Booleans
Module 34: Control Flow and Loops
34.1
Python Operators
34.2
while loop
34.3
List Comprehension
34.4
IN and NOT IN
Your browser does not support the video tag.
Select a lecture to begin